﻿CREATE TABLE [hr].[Doctor] (
    [Id]                   INT           IDENTITY (1, 1) NOT NULL,
    [PersonId]             INT           NOT NULL,
    [DaliyPatientCount]    INT           NOT NULL,
    [HospitalPolyclinicId] INT           NOT NULL,
    [StartDate]            SMALLDATETIME NOT NULL,
    [DepartureDate]        SMALLDATETIME NULL,
    [ExpertiseId]          INT           NOT NULL,
    [Title]                VARCHAR (50)  NULL
);



